UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X9/lqk6GekJm+YHJdShqMZh76kdPbN9THVFHkVLMgeI='
WHERE
key_id = '6a3b97ac43e9c491a07b43db230fd5712ca9e36b9681cc070e4ed9be9dd40b63'
AND (
token = 'X9/lqk6GekJm+YHJdShqMZh76kdPbN9THVFHkVLMgeI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)