UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DZsu10KxSDV3a+wHjOSiTK2e1qUw2Hb/fBn8si0tFv4='
WHERE
key_id = '47d9073d8c7e951241f39a548dadfd40408635780b1f6e9a0c261b557d852ab8'
AND (
token = 'DZsu10KxSDV3a+wHjOSiTK2e1qUw2Hb/fBn8si0tFv4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)