UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1p3T6lIcrWwMKfySQVQKPHv4m1A2ws6T1GPIbWTkkWI='
WHERE
key_id = 'e41b82e80b2838494d8c99b4b08eebbc3c12f898498db0eba8c828a2049c083a'
AND (
token = '1p3T6lIcrWwMKfySQVQKPHv4m1A2ws6T1GPIbWTkkWI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)