UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hCNhyeIlPI3Jd8cxPTKFjJveRC7YQHQ0Slb+4pg8nRA='
WHERE
key_id = '7cf5c74bd3af448f65903a95a945e6cd02b312964535da703d02b4f9cb77b8e9'
AND (
token = 'hCNhyeIlPI3Jd8cxPTKFjJveRC7YQHQ0Slb+4pg8nRA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)