UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ji7YnJx1cu+HnDIXBV66DbjSDiPGyPnbUVBGM2KD4KA='
WHERE
key_id = 'c8c916877e9a3b86732bfa62ab2aa658c56acaf62b679d2e03a4a9993b9bfdf5'
AND (
token = 'ji7YnJx1cu+HnDIXBV66DbjSDiPGyPnbUVBGM2KD4KA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)