UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jiOyV9RqF3adwQhKxIT4wdq8VOx77PzOm8u5nRC5f14='
WHERE
key_id = '3e7a8dfbb3688d23c8c3a0eaa2c7346a815def8e27a3dc27d73c92bdadef2790'
AND (
token = 'jiOyV9RqF3adwQhKxIT4wdq8VOx77PzOm8u5nRC5f14='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)