UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2YpOGXWD4NvcTi3CI+fdiaVuVgg5wOgV1iXo8GwTz70='
WHERE
key_id = '957387df8f7a91634431f92984d9405855b7bf15598d73d729c2f77bacac2011'
AND (
token = '2YpOGXWD4NvcTi3CI+fdiaVuVgg5wOgV1iXo8GwTz70='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)