UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VzWAn7JnjOGELOSMIDHc6fQMZukedudOcvMRm5POSL8='
WHERE
key_id = 'abc9923e8d56638d86a5480fe253477eacfdb0ddfcc77f36c98a8b1d790437d6'
AND (
token = 'VzWAn7JnjOGELOSMIDHc6fQMZukedudOcvMRm5POSL8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)