UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7D+dvw8Hp+XTdOEnCFlIo7Bm+rjU07ZpkTLSJxMDE5I='
WHERE
key_id = 'cfb27f3fb9577c9c5ee7582e6f56b48c7617d8cc64a3d856d325568db58f78dc'
AND (
token = '7D+dvw8Hp+XTdOEnCFlIo7Bm+rjU07ZpkTLSJxMDE5I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)