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