UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7IixHKDdSESOb3EoZ9Q7A++2igFBie7AtwxEKkBeqmI='
WHERE
key_id = '58d67e1caaf0697d31d285ff1b7cea255eb58114e2df5032f1ee092bf5072481'
AND (
token = '7IixHKDdSESOb3EoZ9Q7A++2igFBie7AtwxEKkBeqmI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)