UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'huT1+iEWEGdWX127OO+de6fwi6asZLVWb38SAJJ4k90='
WHERE
key_id = '78baa0574713984d5ed71f555588582c7b3337c413420802a3d7643f3bb7cf22'
AND (
token = 'huT1+iEWEGdWX127OO+de6fwi6asZLVWb38SAJJ4k90='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)