UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HoX+T3BMsldUzKCEF9SjOSz7aVcU4Hk4VHnm2s+a3gs='
WHERE
key_id = 'd6ac016c1d1e11db871f3dd66c7784b2dbd11fa1f088414a2511c40d519d7e98'
AND (
token = 'HoX+T3BMsldUzKCEF9SjOSz7aVcU4Hk4VHnm2s+a3gs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)