UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'imGaPW7dccdA1lAYLcDj2oMUPtyDC76pPRz3jZBJBUc='
WHERE
key_id = '8df24735bce339e51dcff7c193996dbb1b01d80e4584a8c9b96d5284dc901176'
AND (
token = 'imGaPW7dccdA1lAYLcDj2oMUPtyDC76pPRz3jZBJBUc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)