UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pHOrXDraiLsJsPsNkEtgIHDv6T2LyIMXvriT2JbtgY4='
WHERE
key_id = '21c76516a0596b26b03b5e913db69c658714ced65a388a7177c2de92a5ade8c2'
AND (
token = 'pHOrXDraiLsJsPsNkEtgIHDv6T2LyIMXvriT2JbtgY4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)