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