UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5yqYAi6g79OsR0sUIsboVKbn0Whe+U6oij0Yh8J6o+s='
WHERE
key_id = '270ab6823fb534e4b064abbfcbebd494e17231e09df4b8be67301ce3e5526a54'
AND (
token = '5yqYAi6g79OsR0sUIsboVKbn0Whe+U6oij0Yh8J6o+s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)