UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+0mKJvAPOaIYCo5S0gxhfWrJC0Z5eyXjGJL03nJqlUY='
WHERE
key_id = 'b501929b1e37b037293ab59c5a03706512529b646c673806fe7576de071ea27d'
AND (
token = '+0mKJvAPOaIYCo5S0gxhfWrJC0Z5eyXjGJL03nJqlUY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)