UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GSI8J1l0RPXgwt0opIEVhxCZkh3l5aFmdBiTFGIiPSc='
WHERE
key_id = '516f7fff9c29624d63ab3f18ead924570867aacb4b8e28e5391e8b0c995d0309'
AND (
token = 'GSI8J1l0RPXgwt0opIEVhxCZkh3l5aFmdBiTFGIiPSc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)