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