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