UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hIsuZbnw+GAauyHwBdzRuy/4BtbuoDDF5BKwphlwzUk='
WHERE
key_id = 'c9aed9740bb5a994781f7cbfab9948d79507dcc70d97e3ee4413d1d37bf1074c'
AND (
token = 'hIsuZbnw+GAauyHwBdzRuy/4BtbuoDDF5BKwphlwzUk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)