UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VSNIZFhCR05NwTQHMRdvS5Ij75/zCG0el/rS96Kb7Fo='
WHERE
key_id = 'eeffa7815e6149eea3d9ba1bfe85b3a370c8d30a887dd6860b166a27de3e435b'
AND (
token = 'VSNIZFhCR05NwTQHMRdvS5Ij75/zCG0el/rS96Kb7Fo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)