UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X3j5yN/dGXTQmHYRq9vJ0RbXIGk8cgxOTga8bdZDwlk='
WHERE
key_id = '3ec641784658a8564e461b1a5073c37d030360f19586bf2550f81cc9042ce4f2'
AND (
token = 'X3j5yN/dGXTQmHYRq9vJ0RbXIGk8cgxOTga8bdZDwlk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)