UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'o3DpH2LYcwbS3eCQPcbYEcbb7XbOWY5L2Eh47f7GX8c='
WHERE
key_id = '79cd47516431d5161dfe75e214b1ce1ce226cdb0143fe8a74e2ed606cb483dc0'
AND (
token = 'o3DpH2LYcwbS3eCQPcbYEcbb7XbOWY5L2Eh47f7GX8c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)