UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BGBVnr/owEpzRp4bDGCm+UsBrSzs6/LGx8/HtDMFSiQ='
WHERE
key_id = '461ab49a729e0002cd8a7f797dfd70b2e628b37afbf99c750c3fd32238b6c55c'
AND (
token = 'BGBVnr/owEpzRp4bDGCm+UsBrSzs6/LGx8/HtDMFSiQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)