UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '23LQ1/WzgrrGXE957IpiA1s+RFila8483y72beggWZQ='
WHERE
key_id = 'f086abe6ab414c66d81f2b3669fe2a6ac66fd15473ea1c180e40ba4832dcb20e'
AND (
token = '23LQ1/WzgrrGXE957IpiA1s+RFila8483y72beggWZQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)