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