UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'irNV7zTttH+U34L5NY/kFtuJMnSw9PtBCSKjYPUtSHs='
WHERE
key_id = '4f2560293062496e784477a316cd9029e146ebf7e6cdd36df58e94b9b1dea714'
AND (
token = 'irNV7zTttH+U34L5NY/kFtuJMnSw9PtBCSKjYPUtSHs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)