UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hU1FSNpHtDDUFlN02OIn1Q81RnrBidqw/YJkJGEPQRs='
WHERE
key_id = 'bb1a78e591a3ced33b912478a12a45f8b6cfcbe83f66029f0ac7f11af68055a0'
AND (
token = 'hU1FSNpHtDDUFlN02OIn1Q81RnrBidqw/YJkJGEPQRs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)