UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6dY4dZSTu5AcHZ0QtUqcrvPfcnPhxZEi2+EUCdxQ8SQ='
WHERE
key_id = '3775462f02814dfce4f6cd245d0ef28de4a469dc8fe4df0f3aefd4cce7cc1336'
AND (
token = '6dY4dZSTu5AcHZ0QtUqcrvPfcnPhxZEi2+EUCdxQ8SQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)